What's new in this version

Workspace Design

What's New Description
Query Editor

If you are using an On Premise deployment of Sage 200, you can use the Query Editor to create database queries from your Sage 200 database and from third party applications.

This means that you can use information from any source on the workspaces you create.

Content Part Designer

You can use the Content Part Designer to add or remove list, detail and chart content parts within your workspaces.

The Content Part Designer is where you select the type of content part (list, detail or chart), select the datasource that provides the information for the workspace, access the Query Editor (in On Premise deployments of Sage 200), and perform other selections depending on the content part type.

For example, if the content part is a chart, you can enter labels for the X and Y axes. If the content part is a list, you can dd and remove actions and reports.

Sage 200 Financials and Commercials

What's New Description
Sales Orders

Standard items

Enter project analysis for standard items. Standard items of product type stock can be analysed for cost and revenue. All other standard items, including sales order items, can be analysed for revenue.

You can copy sales orders with project analysis.

Sales Returns

Standard items

Enter project analysis for standard items. Standard items of product type stock can be analysed for cost and revenue. All other standard items, including sales order items, can be analysed for revenue.

Additional charges

Enter project analysis for additional charge items. These can be analysed for revenue.

Free text items

Enter project analysis for additional charge items. These can be analysed for revenue.

Sales Quotations

Standard items

Enter project analysis for standard items. Standard items of product type stock can be analysed for cost and revenue. All other standard items, including sales order items, can be analysed for revenue.

You can convert quotations with project analysis to sales orders with project analysis.

Purchase Orders

Purchase orders that are generated to satisfy back to back or direct sales orders do not have project analysis entered. This is to prevent the postings for the cost of the stock being made twice (once from the sales order and once from the purchase order).

When you raise a purchase order to satisfy a sales order with project analysis, and you are entering a standard stock item of Product Type Stock, do not enter project analysis on the purchase order item as well. This will prevent a double posting for the cost of the stock (one from the sales order and one from the purchase order).

Sage 200 Project Accounting

What's new Description
Postings tab in Project Accounting Settings

There is a new Postings tab in Project Accounting Settings. This is where you specify the default derivation of the nominal cost and revenue codes used in project accounting postings for standard stock items (product type stock). The default derivation can be the Project item, or what is set on the Default Accounts tab in SOP Settings.

The Postings tab now also contains the Nominal Settings which were entered previously on the Miscellaneous tab.

Project analysis

Previously, you could analyse project revenue for free text items and additional charge items in sales orders and quotations.

Now you can analyse project cost and revenue for standard stock items (product type stock) in sales orders, returns and quotations, and project revenue in all other items in sales orders, sales returns and quotations.

The following table summarises what you can analyse in sales orders, returns and quotations.

Items Product Type Analyse

Stock items

Stock

Cost and Revenue.

Miscellaneous

Revenue.

Service/Labour

Revenue.

Sales Order Items N/A Revenue.
Additional Charge N/A Revenue.

Free text items

N/A

Revenue.

Project enquiries

There are some new filters and some new criteria included for some of the filters.

Cost Analysis Enquiry

The Customer filter has been added so that you can view projects where a billing schedule has been set up for the specified customer.

The label for the Customer filter is configurable.

Cost Transactions Enquiry

The Document Type filter has been added. You can filter on Sales Order. Sales Return, Sales Quotation, SOP Invoice, SOP Credit Note, Purchase Order or Purchase Return.

Depending on the SOP Setting, Update stock quantities when, and the Document Type filter selected, transactions are displayed as follows:

Update stock quantities when Document Type Displays cost transactions of type

Invoice is posted

SOP Invoice

Stock Issues

Confirmed Price Adjustments

Invoice is posted

SOP Credit Note

Stock Returns

Order despatch is confirmed

No cost transactions are returned.

The Transaction type filter now includes Confirmed Price Adjustment, Sales Order Cost of Sales, Sales Quotation Cost of Sales and Sales Return Cost of Sales.

The Customer filter has been added so that you can view cost of sales transactions relating to a project that you have a billing contract for.

The label for the Customer filter is configurable.

Revenue Transactions Enquiry

The Document Type filter has been added. You can filter on Sales Order, Sales Return, Sales Quotation, SOP Invoice and SOP Credit Note.

If SOP Invoice is selected Sales Invoice tranactions are displayed.

If SOP Credit Note is selected, Sales Credit Note transactions are displayed.

The Transaction type filter now includes the Sales Return.

The Stock Item filter has been added so that you can view any cost of sales transactions related to a project that you have a billing contract for.

Project reports

Various criteria have been added to analysis and transactions reports as follows.

You can enable these in Report Designer, using Report > Manage Criteria > Modify. You can disable any criteria that you don't want to use at the same time.

Report Criterion
Analysis Customer

Cost Transactions

Sales Return
SOP Invoice
SOP Credit Note

Revenue Transactions

Sales Return
SOP Invoice
SOP Credit Note
Stock Item